import pandas as pd
path=r"D:\Pyobject2023\object\Case\素材"
df=pd.read_excel(path+r"\1.01.xlsx","总表")
print(df)
df1=df.loc[:,['语文','英语','数学']]
print(df1)
column_order=['语文','英语','数学']
df0=df[column_order]
print(df0)
df2=df.rename(columns={'语文':"物理",'英语':"化学",'数学':"生物"})
print(df2)
返回：
| 姓名 | 数学 | 语文 | 英语 | |
| 0 | 小明 | 85.5 | 67 | 84.0 |
| 1 | 老张 | 89.0 | 100 | 34.0 |
| 2 | 小王 | 95.0 | 55 | 34.0 |
| 3 | 小李 | 23.0 | 95 | NaN |
| 4 | 老六 | NaN | 43 | 99.0 |
| 5 | 小王 | 100.0 | 66 | 65.0 |
| 6 | 小李 | 13.0 | 22 | 33.0 |
| 语文 | 英语 | 数学 | |
| 0 | 67 | 84.0 | 85.5 |
| 1 | 100 | 34.0 | 89.0 |
| 2 | 55 | 34.0 | 95.0 |
| 3 | 95 | NaN | 23.0 |
| 4 | 43 | 99.0 | NaN |
| 5 | 66 | 65.0 | 100.0 |
| 6 | 22 | 33.0 | 13.0 |
| 语文 | 英语 | 数学 | |
| 0 | 67 | 84.0 | 85.5 |
| 1 | 100 | 34.0 | 89.0 |
| 2 | 55 | 34.0 | 95.0 |
| 3 | 95 | NaN | 23.0 |
| 4 | 43 | 99.0 | NaN |
| 5 | 66 | 65.0 | 100.0 |
| 6 | 22 | 33.0 | 13.0 |
| 姓名 | 生物 | 物理 | 化学 | |
| 0 | 小明 | 85.5 | 67 | 84.0 |
| 1 | 老张 | 89.0 | 100 | 34.0 |
| 2 | 小王 | 95.0 | 55 | 34.0 |
| 3 | 小李 | 23.0 | 95 | NaN |
| 4 | 老六 | NaN | 43 | 99.0 |
| 5 | 小王 | 100.0 | 66 | 65.0 |
| 6 | 小李 | 13.0 | 22 | 33.0 |